package com.ping.model;


public class User extends BaseModel<User>{
	private static final long serialVersionUID = 1L;
	
	public static final String TABLE_NAME = "monkey_user";
	
	public static final String UUID = "uuid";
	public static final String NAME = "name";
	public static final String PHONE = "phone";
	public static final String EMAIL = "email";
	public static final String CHATHEAD = "chathead";
	public static final String EXPOSE = "expose";
	public static final String SEX = "sex";
	public static final String CRATE = "crate";
	public static final String PWD = "pwd";
	
	
	public static final String SQL_GET_USER_PHONE = 
			"SELECT phone FROM monkey_user WHERE uuid=?";
	public static final String SQL_GET_BY_NAME7PWD = 
			"SELECT * FROM monkey_user WHERE phone=? and pwd=?";
	public static final String SQL_GET_USER_SHORT_INFO = 
			"SELECT name, crate, sex, chathead FROM monkey_user WHERE uuid=?";
	public static final String SQL_GET_UUID_BY_TOKEN =
			"SELECT uuid FROM monkey_user where token=?";
}